---
title: SAIF.Application.Claim.Legal stored procedures
summary: Oracle stored procedures and package members referenced by this library.
status: draft
owner: SAIF Documentation Generator
last_reviewed: 2026-08-31
library: SAIF.Application.Claim.Legal
reference_type: embedded
---

# SAIF.Application.Claim.Legal stored procedures

This page catalogs Oracle package members invoked by this library from the `WCIS_DBA.pk80001_legalnet` package. Real Oracle PL/SQL source was retrieved for the package via the Legends CLI (`legends oracle query --name pk80001_legalnet`, schema `WCIS_DBA`) on 2026-08-31: both package specification and body were returned (98 enumerated members, 148,911 characters total). `insertLetterRequest` is a confirmed member with extracted signature and verified call sites. `getHeader` references by the calling code but is not present in the retrieved package artifact — this is documented as a member-level absence (`not-found-by-cli` status) within an otherwise-`found` package. `get_atty_mngr_email` is unchanged as per task scope.

## Procedure catalog

| Package / Procedure | Schema | Type | Purpose | Calling business objects |
| --- | --- | --- | --- | --- |
| [`insertLetterRequest`](pk80001-legalnet-insertletterrequest.md) | `WCIS_DBA` | PROCEDURE | CommandType.StoredProcedure via IPortalRequest / IDataRequest supporting `LegalManagerBase`; creates a `LETTER_REQUEST` row and returns its newly generated sequence number. Letter type codes: `RREQ` (recon request), `DEFLT` (Defense Eval Form). | `clsRequestManager`, `clsScheduleManager` |
| [`getHeader`](pk80001-legalnet-getheader.md) | `WCIS_DBA` | PROCEDURE (inferred from caller) | CommandType.StoredProcedure + AddCursorParm via SqlHelper.ResultSetQuery supporting `clsLegalData`; retrieves legal-case header information — case number, attorney name, case status, hearing date. **Member not present in retrieved package.** | `clsLegalData` |
| [`get_atty_mngr_email`](pk80001-legalnet-get-atty-mngr-email.md) | `WCIS_DBA` | FUNCTION | Scalar query against Oracle `DUAL` that calls `pk80001_LEGALNET.get_atty_mngr_email` to resolve the DEF notification recipient for `clsScheduleManager` | `clsScheduleManager` |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [SQL catalog](../sql/index.md)
- [API reference](../api/index.md)

## Sources
- `SAIF.Application.Claim.Legal\LegalManagerBase.vb` (insertLetterRequest wrapper and call site via clsRequestManager.vb:261)
- `SAIF.Application.Claim.Legal\clsLegalData.vb` (getHeader call site, constructor, result-set reader)
- `SAIF.Application.Claim.Legal\LegalNet\clsScheduleManager.vb` (insertLetterRequest call site for DEFLT letter type)
- `SAIF.Application.Claim.Legal\clsRequestManager.vb` (insertLetterRequest call site for RREQ letter type)
- Oracle Legends CLI query: `legends oracle query --name pk80001_legalnet` (2026-08-31T21:20:00Z)